package com.lemontree.serviceImpl;

import java.util.List;
import java.util.Map;

import com.lemontree.service.ClassService;
import com.lemontree.utils.DBUtils;

public class ClassServiceImpl implements ClassService {

	static DBUtils db = null;
	
	static{
		db = new DBUtils();
	}
	
	@Override
	public List<Map<String, String>> query(String sql) {
		return db.queryByList(sql);
	}

	@Override
	public List<Map<String, String>> getSytatus(int flag) {
			String sql = "SELECT * FROM classinfo WHERE rid= "+flag;
		return db.queryByList(sql);
	}

	@Override
	public List<Map<String, String>> getAllStatus() {
		String sql = "SELECT * FROM classinfo ";
		return db.queryByList(sql);
	}

}
